-- @owner: lvlintao
-- @date: 2025-11-18
-- @testpoint: D兼容性-触发器中使用'< >'操作，成功
@connect PrimaryDbDmode;

--step1 建表;expect:成功
drop table if exists case0010;
create table case0010(id int, name char(30));

--step2 创建函数，触发器;expect:成功
create or replace function insert_fun1 returns trigger as
$d$
declare
  output boolean;
begin
  select 2 < >3 into output;
  raise info 'INFO:%',output;
  return new;
end;
$d$ language plpgsql;
/
drop trigger if exists test_trigger1 on case0010;
create trigger test_trigger1 after insert on case0010
for each row
execute procedure insert_fun1();/
insert into case0010 values(1,'abc');

--step2 清理环境;expect:成功
drop trigger test_trigger1 on case0010;
drop function if exists insert_fun1;
drop table if exists case0010;


